CREATE LOGIN administrator WITH PASSWORD='admin'
CREATE LOGIN test2 WITH PASSWORD='test2'
GO

CREATE USER administrator FOR LOGIN administrator
CREATE USER test2 FOR LOGIN test2
GO

GRANT SELECT TO administrator
GRANT INSERT TO administrator
GRANT UPDATE TO administrator
GRANT DELETE TO administrator
GRANT EXECUTE TO administrator
GRANT REFERENCES TO administrator
GO 